{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["VRP Solver Console","1.Locations","2.Distances"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"VRP Solver Console","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Sequence","Parameter","Value","Remarks"]
["0.Optional - GIS License","Bing Maps Key",null,"You can get a free key at https://www.bingmapsportal.com/"]
[]
["1.Locations","Number of depots",1,"[1,20]"]
[null,"Number of customers",7,"[5,200]"]
[]
["2.Distances","Distance / duration computation","Bird flight distances (km)","Recommendation: use postcodes for addresses"]
[null,"Bing Maps route type","Fastest","Recommendation: use Fastest"]
[null,"Average vehicle speed",70,"Not used for the 'Bing Maps driving distances' options"]
[]
["3.Vehicles","Number of vehicle types",2,"Heterogeneous VRP if greater than 1"]
[]
["4.Solution","Vehicles must return to the depot?","Yes","Open VRP if no return"]
[null,"Time window type","Hard"]
[null,"Backhauls?","No","If activated, delivery locations must be visited before pickup locations"]
[]
["5.Optional - Visualization","Visualization background","Bing Maps"]
[null,"Location labels","Location IDs"]
[]
["6.Solver","Warm start?","Yes"]
[null,"Show progress on the status bar?","No","May slow down the optimization algorithm  "]
[null,"CPU time limit (seconds)",120,{"$f":"CONCATENATE(\"Recommendation: At least \", 60 * CEILING(C5 * C5 * C5 / 100000, 1),\" seconds\")","v":"Recommendation: At least 60 seconds"}]

{"sheet":"1.Locations","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Location ID","Name","Address","Latitude (y)","Longitude (x)","Time window start","Time window end","Must be visited?","Service time","Pickup amount","Delivery amount","Profit"]
[0,"Depot",null,null,null,"00:00:00","23:59:00","Starting location",0,0,0,0]
[1,"Customer 1",null,null,null,"00:02:00","00:15:00","Must be visited",1.3888888888888889E-3,0,45,0]
[2,"Customer 2",null,null,null,"00:08:00","00:20:00","Must be visited",2.7777777777777779E-3,0,50,0]
[3,"Customer 3",null,null,null,"00:10:00","00:30:00","Must be visited",1.3888888888888889E-3,0,30,0]
[4,"Customer 4",null,null,null,"00:02:00","00:15:00","Must be visited",2.0833333333333333E-3,0,20,0]
[5,"Customer 5",null,null,null,"00:10:00","00:30:00","Must be visited",2.7777777777777779E-3,0,25,0]
[6,"Customer 6",null,null,null,"00:10:00","00:30:00","Must be visited",1.3888888888888889E-3,0,35,0]
[7,"Customer 7",null,null,null,"00:15:00","00:40:00","Must be visited",2.0833333333333333E-3,0,30,0]

{"sheet":"2.Distances","index":2,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["From","To","Distance","Duration","Method:"]
["Depot","Depot",0,0]
["Depot","Customer 1",10,6.9444444444444441E-3]
["Depot","Customer 2",8,5.5555555555555558E-3]
["Depot","Customer 3",7,4.8611111111111112E-3]
["Depot","Customer 4",6,4.1666666666666666E-3]
["Depot","Customer 5",4,2.7777777777777779E-3]
["Depot","Customer 6",5,3.472222222222222E-3]
["Depot","Customer 7",6,4.1666666666666666E-3]
["Customer 1","Depot",8,5.5555555555555558E-3]
["Customer 1","Customer 1",0,0]
["Customer 1","Customer 2",4,2.7777777777777779E-3]
["Customer 1","Customer 3",2,1.3888888888888889E-3]
["Customer 1","Customer 4",5,3.472222222222222E-3]
["Customer 1","Customer 5",3,2.0833333333333333E-3]
["Customer 1","Customer 6",2,1.3888888888888889E-3]
["Customer 1","Customer 7",5,3.472222222222222E-3]
["Customer 2","Depot",10,6.9444444444444441E-3]
["Customer 2","Customer 1",4,2.7777777777777779E-3]
["Customer 2","Customer 2",0,0]
["Customer 2","Customer 3",5,3.472222222222222E-3]
["Customer 2","Customer 4",2,1.3888888888888889E-3]
["Customer 2","Customer 5",3,2.0833333333333333E-3]
["Customer 2","Customer 6",4,2.7777777777777779E-3]
["Customer 2","Customer 7",1,6.9444444444444447E-4]
["Customer 3","Depot",6,4.1666666666666666E-3]
["Customer 3","Customer 1",3,2.0833333333333333E-3]
["Customer 3","Customer 2",4,2.7777777777777779E-3]
["Customer 3","Customer 3",0,0]
["Customer 3","Customer 4",2,1.3888888888888889E-3]
["Customer 3","Customer 5",5,3.472222222222222E-3]
["Customer 3","Customer 6",6,4.1666666666666666E-3]
["Customer 3","Customer 7",1,6.9444444444444447E-4]
["Customer 4","Depot",5,3.472222222222222E-3]
["Customer 4","Customer 1",4,2.7777777777777779E-3]
["Customer 4","Customer 2",3,2.0833333333333333E-3]
["Customer 4","Customer 3",3,2.0833333333333333E-3]
["Customer 4","Customer 4",0,0]
["Customer 4","Customer 5",5,3.472222222222222E-3]
["Customer 4","Customer 6",6,4.1666666666666666E-3]
["Customer 4","Customer 7",2,1.3888888888888889E-3]
["Customer 5","Depot",6,4.1666666666666666E-3]
["Customer 5","Customer 1",3,2.0833333333333333E-3]
["Customer 5","Customer 2",1,6.9444444444444447E-4]
["Customer 5","Customer 3",6,4.1666666666666666E-3]
["Customer 5","Customer 4",4,2.7777777777777779E-3]
["Customer 5","Customer 5",0,0]
["Customer 5","Customer 6",8,5.5555555555555558E-3]
["Customer 5","Customer 7",2,1.3888888888888889E-3]
["Customer 6","Depot",7,4.8611111111111112E-3]
["Customer 6","Customer 1",2,1.3888888888888889E-3]
["Customer 6","Customer 2",5,3.472222222222222E-3]
["Customer 6","Customer 3",5,3.472222222222222E-3]
["Customer 6","Customer 4",7,4.8611111111111112E-3]
["Customer 6","Customer 5",5,3.472222222222222E-3]
["Customer 6","Customer 6",0,0]
["Customer 6","Customer 7",3,2.0833333333333333E-3]
["Customer 7","Depot",8,5.5555555555555558E-3]
["Customer 7","Customer 1",5,3.472222222222222E-3]
["Customer 7","Customer 2",2,1.3888888888888889E-3]
["Customer 7","Customer 3",4,2.7777777777777779E-3]
["Customer 7","Customer 4",3,2.0833333333333333E-3]
["Customer 7","Customer 5",6,4.1666666666666666E-3]
["Customer 7","Customer 6",5,3.472222222222222E-3]
["Customer 7","Customer 7",0,0]